20210513_Challenge_AA_MANANA Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	9266614
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.3 GiB
Average record size in memory	156.0 B

Variable types

Categorical	5
Numeric	14
Unsupported	1

Alerts

`MES` is highly overall correlated with `CLIENTE`	High correlation
`CLIENTE` is highly overall correlated with `MES` and 1 other fields	High correlation
`MORAS` is highly overall correlated with `M1` and 1 other fields	High correlation
`MARCACIONES` is highly overall correlated with `M1`	High correlation
`M1` is highly overall correlated with `MORAS` and 2 other fields	High correlation
`M2` is highly overall correlated with `MORAS` and 2 other fields	High correlation
`M3` is highly overall correlated with `M2` and 1 other fields	High correlation
`C3` is highly overall correlated with `M3`	High correlation
`ANIO` is highly overall correlated with `CLIENTE`	High correlation
`INGRESO` is highly skewed (γ1 = 23.7257702)	Skewed
`FECHANACIMIENTO` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`INGRESO` has 568032 (6.1%) zeros	Zeros
`CONTACTOS` has 4951354 (53.4%) zeros	Zeros
`M1` has 3220844 (34.8%) zeros	Zeros
`C1` has 6567714 (70.9%) zeros	Zeros
`M2` has 4422040 (47.7%) zeros	Zeros
`C2` has 7017791 (75.7%) zeros	Zeros
`M3` has 5348889 (57.7%) zeros	Zeros
`C3` has 7399318 (79.8%) zeros	Zeros
`ANTIGUEDAD` has 3987610 (43.0%) zeros	Zeros

Reproduction

Analysis started	2023-06-12 22:05:34.328081
Analysis finished	2023-06-12 22:25:33.388454
Duration	19 minutes and 59.06 seconds
Software version	ydata-profiling vv4.2.0
Download configuration	config.json

ANIO
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	141.4 MiB

2019	6822569
2020	2444045

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	37066456
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2019
2nd row	2019
3rd row	2019
4th row	2019
5th row	2019

Common Values

Value	Count	Frequency (%)
2019	6822569	73.6%
2020	2444045	26.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2019	6822569	73.6%
2020	2444045	26.4%

Most occurring characters

Value	Count	Frequency (%)
2	11710659	31.6%
0	11710659	31.6%
1	6822569	18.4%
9	6822569	18.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	37066456	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	11710659	31.6%
0	11710659	31.6%
1	6822569	18.4%
9	6822569	18.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	37066456	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	11710659	31.6%
0	11710659	31.6%
1	6822569	18.4%
9	6822569	18.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37066456	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	11710659	31.6%
0	11710659	31.6%
1	6822569	18.4%
9	6822569	18.4%

MES
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.2257026

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	141.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.6335378
Coefficient of variation (CV)	0.58363498
Kurtosis	-1.3163862
Mean	6.2257026
Median Absolute Deviation (MAD)	3
Skewness	0.15284969
Sum	57691183
Variance	13.202597
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	1040183	11.2%
2	995957	10.7%
12	941402	10.2%
1	893419	9.6%
5	732618	7.9%
6	718674	7.8%
10	717661	7.7%
11	707744	7.6%
7	685663	7.4%
9	672976	7.3%
Other values (2)	1160317	12.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	893419	9.6%
2	995957	10.7%
3	1040183	11.2%
4	671853	7.3%
5	732618	7.9%
6	718674	7.8%
7	685663	7.4%
8	488464	5.3%
9	672976	7.3%
10	717661	7.7%

Value	Count	Frequency (%)
12	941402	10.2%
11	707744	7.6%
10	717661	7.7%
9	672976	7.3%
8	488464	5.3%
7	685663	7.4%
6	718674	7.8%
5	732618	7.9%
4	671853	7.3%
3	1040183	11.2%

CLIENTE
Real number (ℝ)

Distinct	9264976
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7674337 × 10¹²

Minimum	2.0191121 × 10⁸
Maximum	2.0201282 × 10¹³
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	141.4 MiB

Quantile statistics

Minimum	2.0191121 × 10⁸
5-th percentile	2.0194776 × 10¹¹
Q1	2.0193247 × 10¹²
median	2.0197516 × 10¹²
Q3	2.0205423 × 10¹²
95-th percentile	2.0201115 × 10¹³
Maximum	2.0201282 × 10¹³
Range	2.020108 × 10¹³
Interquartile range (IQR)	1.217568 × 10⁹

Descriptive statistics

Standard deviation	7.6535534 × 10¹²
Coefficient of variation (CV)	1.3270293
Kurtosis	-0.16758324
Mean	5.7674337 × 10¹²
Median Absolute Deviation (MAD)	5.3373361 × 10⁸
Skewness	1.3390664
Sum	-1.89565 × 10¹⁸
Variance	5.8576879 × 10²⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.019129672 × 10¹²	2	< 0.1%
2.019129053 × 10¹²	2	< 0.1%
2.019119449 × 10¹²	2	< 0.1%
2.019119069 × 10¹²	2	< 0.1%
2.020126497 × 10¹²	2	< 0.1%
2.019119168 × 10¹²	2	< 0.1%
2.020124741 × 10¹²	2	< 0.1%
2.019126578 × 10¹²	2	< 0.1%
2.019116939 × 10¹²	2	< 0.1%
2.019127053 × 10¹²	2	< 0.1%
Other values (9264966)	9266594	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201911206	1	< 0.1%
201911230	1	< 0.1%
201911299	1	< 0.1%
201911324	1	< 0.1%
201911601	1	< 0.1%
201911752	1	< 0.1%
201911773	1	< 0.1%
201911797	1	< 0.1%
201911844	1	< 0.1%
201911999	1	< 0.1%

Value	Count	Frequency (%)
2.020128221 × 10¹³	1	< 0.1%
2.020128221 × 10¹³	1	< 0.1%
2.020128221 × 10¹³	1	< 0.1%
2.02012822 × 10¹³	1	< 0.1%
2.02012822 × 10¹³	1	< 0.1%
2.02012822 × 10¹³	1	< 0.1%
2.02012822 × 10¹³	1	< 0.1%
2.02012822 × 10¹³	1	< 0.1%
2.02012822 × 10¹³	1	< 0.1%
2.02012822 × 10¹³	1	< 0.1%

ESTADO
Categorical

Distinct	32
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	141.4 MiB

ESTADO DE MEXICO	1265732
VERACRUZ	722681
JALISCO	539577
CIUDAD DE MEXICO	473351
GUANAJUATO	471944
Other values (27)	5793329

Length

Max length	21
Median length	16
Mean length	10.208601
Min length	6

Characters and Unicode

Total characters	94599166
Distinct characters	25
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	JALISCO
2nd row	VERACRUZ
3rd row	CHIAPAS
4th row	TAMAULIPAS
5th row	ESTADO DE MEXICO

Common Values

Value	Count	Frequency (%)
ESTADO DE MEXICO	1265732	13.7%
VERACRUZ	722681	7.8%
JALISCO	539577	5.8%
CIUDAD DE MEXICO	473351	5.1%
GUANAJUATO	471944	5.1%
SINALOA	462219	5.0%
PUEBLA	426476	4.6%
MICHOACAN	380609	4.1%
NUEVO LEON	347600	3.8%
BAJA CALIFORNIA NORTE	326549	3.5%
Other values (22)	3849876	41.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mexico	1739083	12.0%
de	1739083	12.0%
estado	1265732	8.8%
veracruz	722681	5.0%
jalisco	539577	3.7%
ciudad	473351	3.3%
guanajuato	471944	3.3%
sinaloa	462219	3.2%
puebla	426476	3.0%
baja	419292	2.9%
Other values (30)	6193709	42.9%

Most occurring characters

Value	Count	Frequency (%)
A	14738419	15.6%
O	9314345	9.8%
E	8286933	8.8%
C	6689542	7.1%
I	6491004	6.9%
	5186533	5.5%
U	5149995	5.4%
S	4360280	4.6%
D	4304728	4.6%
R	4159905	4.4%
Other values (15)	25917482	27.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	89412633	94.5%
Space Separator	5186533	5.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	14738419	16.5%
O	9314345	10.4%
E	8286933	9.3%
C	6689542	7.5%
I	6491004	7.3%
U	5149995	5.8%
S	4360280	4.9%
D	4304728	4.8%
R	4159905	4.7%
N	4030168	4.5%
Other values (14)	21887314	24.5%

Space Separator

Value	Count	Frequency (%)
	5186533	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	89412633	94.5%
Common	5186533	5.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	14738419	16.5%
O	9314345	10.4%
E	8286933	9.3%
C	6689542	7.5%
I	6491004	7.3%
U	5149995	5.8%
S	4360280	4.9%
D	4304728	4.8%
R	4159905	4.7%
N	4030168	4.5%
Other values (14)	21887314	24.5%

Common

Value	Count	Frequency (%)
	5186533	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	94599166	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	14738419	15.6%
O	9314345	9.8%
E	8286933	8.8%
C	6689542	7.1%
I	6491004	6.9%
	5186533	5.5%
U	5149995	5.4%
S	4360280	4.6%
D	4304728	4.6%
R	4159905	4.4%
Other values (15)	25917482	27.4%

INGRESO
Real number (ℝ)

SKEWED ZEROS

Distinct	15986
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9092.36

Minimum	0
Maximum	2000013
Zeros	568032
Zeros (%)	6.1%
Negative	0
Negative (%)	0.0%
Memory size	141.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6000
median	8000
Q3	11000
95-th percentile	20000
Maximum	2000013
Range	2000013
Interquartile range (IQR)	5000

Descriptive statistics

Standard deviation	7474.5292
Coefficient of variation (CV)	0.82206702
Kurtosis	4099.4655
Mean	9092.36
Median Absolute Deviation (MAD)	2100
Skewness	23.72577
Sum	8.425539 × 10¹⁰
Variance	55868587
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8000	1090779	11.8%
6000	897621	9.7%
10000	782103	8.4%
12000	645310	7.0%
0	568032	6.1%
5000	440763	4.8%
7000	422493	4.6%
15000	381479	4.1%
9000	342057	3.7%
4000	332174	3.6%
Other values (15976)	3363803	36.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	568032	6.1%
0.01	44	< 0.1%
0.05	5	< 0.1%
0.08	8	< 0.1%
0.1	20	< 0.1%
0.3	9	< 0.1%
0.5	19	< 0.1%
1	5396	0.1%
2	334	< 0.1%
3	274	< 0.1%

Value	Count	Frequency (%)
2000013	6	< 0.1%
1000028	10	< 0.1%
1000000	12	< 0.1%
320003	3	< 0.1%
250000	346	< 0.1%
249750	2	< 0.1%
245000	1	< 0.1%
240000	45	< 0.1%
230000	10	< 0.1%
227000	7	< 0.1%

MORAS
Real number (ℝ)

Distinct	32
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.6533287

Minimum	1
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	106.0 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	7
Maximum	36
Range	35
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.0957714
Coefficient of variation (CV)	0.78986496
Kurtosis	3.004146
Mean	2.6533287
Median Absolute Deviation (MAD)	1
Skewness	1.4176305
Sum	24587373
Variance	4.3922577
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
1	4115519	44.4%
2	1674671	18.1%
3	937651	10.1%
4	727109	7.8%
5	603888	6.5%
6	509919	5.5%
7	371065	4.0%
8	282357	3.0%
9	24378	0.3%
10	9156	0.1%
Other values (22)	10901	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4115519	44.4%
2	1674671	18.1%
3	937651	10.1%
4	727109	7.8%
5	603888	6.5%
6	509919	5.5%
7	371065	4.0%
8	282357	3.0%
9	24378	0.3%
10	9156	0.1%

Value	Count	Frequency (%)
36	10	< 0.1%
34	32	< 0.1%
30	119	< 0.1%
29	83	< 0.1%
28	78	< 0.1%
27	81	< 0.1%
26	102	< 0.1%
25	106	< 0.1%
24	156	< 0.1%
23	185	< 0.1%

SEXO
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	141.4 MiB

F	5233816
M	4032798

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	9266614
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	F
4th row	M
5th row	F

Common Values

Value	Count	Frequency (%)
F	5233816	56.5%
M	4032798	43.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
f	5233816	56.5%
m	4032798	43.5%

Most occurring characters

Value	Count	Frequency (%)
F	5233816	56.5%
M	4032798	43.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	9266614	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	5233816	56.5%
M	4032798	43.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9266614	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	5233816	56.5%
M	4032798	43.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9266614	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	5233816	56.5%
M	4032798	43.5%

ESTADOCIVIL
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	141.4 MiB

C	4249606
S	3101934
U	1536087
V	207191
D	171796

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	9266614
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	S
2nd row	C
3rd row	S
4th row	U
5th row	U

Common Values

Value	Count	Frequency (%)
C	4249606	45.9%
S	3101934	33.5%
U	1536087	16.6%
V	207191	2.2%
D	171796	1.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
c	4249606	45.9%
s	3101934	33.5%
u	1536087	16.6%
v	207191	2.2%
d	171796	1.9%

Most occurring characters

Value	Count	Frequency (%)
C	4249606	45.9%
S	3101934	33.5%
U	1536087	16.6%
V	207191	2.2%
D	171796	1.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	9266614	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	4249606	45.9%
S	3101934	33.5%
U	1536087	16.6%
V	207191	2.2%
D	171796	1.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9266614	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	4249606	45.9%
S	3101934	33.5%
U	1536087	16.6%
V	207191	2.2%
D	171796	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9266614	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	4249606	45.9%
S	3101934	33.5%
U	1536087	16.6%
V	207191	2.2%
D	171796	1.9%

FECHANACIMIENTO
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	141.4 MiB

MARCACIONES
Real number (ℝ)

Distinct	1367
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.661626

Minimum	1
Maximum	2342
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	141.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	7
median	26
Q3	67
95-th percentile	196
Maximum	2342
Range	2341
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	73.77483
Coefficient of variation (CV)	1.400922
Kurtosis	20.627822
Mean	52.661626
Median Absolute Deviation (MAD)	22
Skewness	3.343748
Sum	4.8799496 × 10⁸
Variance	5442.7256
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	486933	5.3%
2	415281	4.5%
3	359164	3.9%
4	333691	3.6%
6	287103	3.1%
5	282011	3.0%
7	237659	2.6%
8	217871	2.4%
9	175105	1.9%
10	164710	1.8%
Other values (1357)	6307086	68.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	486933	5.3%
2	415281	4.5%
3	359164	3.9%
4	333691	3.6%
5	282011	3.0%
6	287103	3.1%
7	237659	2.6%
8	217871	2.4%
9	175105	1.9%
10	164710	1.8%

Value	Count	Frequency (%)
2342	1	< 0.1%
2332	1	< 0.1%
2276	1	< 0.1%
2260	1	< 0.1%
2174	1	< 0.1%
2060	1	< 0.1%
2000	1	< 0.1%
1980	1	< 0.1%
1972	1	< 0.1%
1952	1	< 0.1%

CONTACTOS
Real number (ℝ)

Distinct	110
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5000805

Minimum	0
Maximum	128
Zeros	4951354
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	141.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	7
Maximum	128
Range	128
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	3.2906071
Coefficient of variation (CV)	2.1936203
Kurtosis	54.172978
Mean	1.5000805
Median Absolute Deviation (MAD)	0
Skewness	5.6605685
Sum	13900667
Variance	10.828095
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4951354	53.4%
1	1853537	20.0%
2	897248	9.7%
3	480147	5.2%
4	288679	3.1%
5	185722	2.0%
6	130699	1.4%
7	93232	1.0%
8	70755	0.8%
9	53985	0.6%
Other values (100)	261256	2.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4951354	53.4%
1	1853537	20.0%
2	897248	9.7%
3	480147	5.2%
4	288679	3.1%
5	185722	2.0%
6	130699	1.4%
7	93232	1.0%
8	70755	0.8%
9	53985	0.6%

Value	Count	Frequency (%)
128	1	< 0.1%
125	1	< 0.1%
113	1	< 0.1%
111	1	< 0.1%
109	3	< 0.1%
108	2	< 0.1%
106	1	< 0.1%
104	2	< 0.1%
102	1	< 0.1%
101	1	< 0.1%

M1
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1363
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.511071

Minimum	0
Maximum	2342
Zeros	3220844
Zeros (%)	34.8%
Negative	0
Negative (%)	0.0%
Memory size	141.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	6
Q3	43
95-th percentile	177
Maximum	2342
Range	2342
Interquartile range (IQR)	43

Descriptive statistics

Standard deviation	70.734484
Coefficient of variation (CV)	1.8856962
Kurtosis	25.338319
Mean	37.511071
Median Absolute Deviation (MAD)	6
Skewness	3.8226151
Sum	3.4760062 × 10⁸
Variance	5003.3672
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3220844	34.8%
1	366154	4.0%
2	302764	3.3%
3	231958	2.5%
4	205427	2.2%
6	173065	1.9%
5	170345	1.8%
7	131931	1.4%
8	120672	1.3%
9	97503	1.1%
Other values (1353)	4245951	45.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3220844	34.8%
1	366154	4.0%
2	302764	3.3%
3	231958	2.5%
4	205427	2.2%
5	170345	1.8%
6	173065	1.9%
7	131931	1.4%
8	120672	1.3%
9	97503	1.1%

Value	Count	Frequency (%)
2342	1	< 0.1%
2332	1	< 0.1%
2276	1	< 0.1%
2260	1	< 0.1%
2174	1	< 0.1%
2060	1	< 0.1%
2000	1	< 0.1%
1980	1	< 0.1%
1972	1	< 0.1%
1952	1	< 0.1%

C1
Real number (ℝ)

Distinct	110
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0054215

Minimum	0
Maximum	128
Zeros	6567714
Zeros (%)	70.9%
Negative	0
Negative (%)	0.0%
Memory size	141.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	5
Maximum	128
Range	128
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.9322511
Coefficient of variation (CV)	2.9164396
Kurtosis	77.368529
Mean	1.0054215
Median Absolute Deviation (MAD)	0
Skewness	6.8698641
Sum	9316853
Variance	8.5980965
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6567714	70.9%
1	1114772	12.0%
2	549689	5.9%
3	302234	3.3%
4	185388	2.0%
5	120613	1.3%
6	86648	0.9%
7	62455	0.7%
8	48367	0.5%
9	37308	0.4%
Other values (100)	191426	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6567714	70.9%
1	1114772	12.0%
2	549689	5.9%
3	302234	3.3%
4	185388	2.0%
5	120613	1.3%
6	86648	0.9%
7	62455	0.7%
8	48367	0.5%
9	37308	0.4%

Value	Count	Frequency (%)
128	1	< 0.1%
125	1	< 0.1%
113	1	< 0.1%
111	1	< 0.1%
109	3	< 0.1%
108	2	< 0.1%
106	1	< 0.1%
104	2	< 0.1%
102	1	< 0.1%
101	1	< 0.1%

M2
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1332
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.301706

Minimum	0
Maximum	2342
Zeros	4422040
Zeros (%)	47.7%
Negative	0
Negative (%)	0.0%
Memory size	141.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	26
95-th percentile	145
Maximum	2342
Range	2342
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	62.462259
Coefficient of variation (CV)	2.2878519
Kurtosis	37.043018
Mean	27.301706
Median Absolute Deviation (MAD)	1
Skewness	4.6600524
Sum	2.5299437 × 10⁸
Variance	3901.5338
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4422040	47.7%
1	382825	4.1%
2	295313	3.2%
3	214534	2.3%
4	183463	2.0%
5	144823	1.6%
6	141747	1.5%
7	107493	1.2%
8	99706	1.1%
9	80027	0.9%
Other values (1322)	3194643	34.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4422040	47.7%
1	382825	4.1%
2	295313	3.2%
3	214534	2.3%
4	183463	2.0%
5	144823	1.6%
6	141747	1.5%
7	107493	1.2%
8	99706	1.1%
9	80027	0.9%

Value	Count	Frequency (%)
2342	1	< 0.1%
2332	1	< 0.1%
2260	1	< 0.1%
2174	1	< 0.1%
2060	1	< 0.1%
2000	1	< 0.1%
1980	1	< 0.1%
1972	1	< 0.1%
1952	1	< 0.1%
1948	1	< 0.1%

C2
Real number (ℝ)

Distinct	106
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.78674929

Minimum	0
Maximum	125
Zeros	7017791
Zeros (%)	75.7%
Negative	0
Negative (%)	0.0%
Memory size	141.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	4
Maximum	125
Range	125
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.5551473
Coefficient of variation (CV)	3.2477275
Kurtosis	101.0842
Mean	0.78674929
Median Absolute Deviation (MAD)	0
Skewness	7.8037527
Sum	7290502
Variance	6.5287777
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7017791	75.7%
1	988036	10.7%
2	458176	4.9%
3	242414	2.6%
4	146223	1.6%
5	93983	1.0%
6	66656	0.7%
7	47380	0.5%
8	36660	0.4%
9	27970	0.3%
Other values (96)	141325	1.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7017791	75.7%
1	988036	10.7%
2	458176	4.9%
3	242414	2.6%
4	146223	1.6%
5	93983	1.0%
6	66656	0.7%
7	47380	0.5%
8	36660	0.4%
9	27970	0.3%

Value	Count	Frequency (%)
125	1	< 0.1%
113	1	< 0.1%
111	1	< 0.1%
109	1	< 0.1%
108	2	< 0.1%
104	2	< 0.1%
101	1	< 0.1%
100	1	< 0.1%
99	2	< 0.1%
97	1	< 0.1%

M3
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1301
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.300339

Minimum	0
Maximum	2342
Zeros	5348889
Zeros (%)	57.7%
Negative	0
Negative (%)	0.0%
Memory size	141.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	12
95-th percentile	118
Maximum	2342
Range	2342
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	54.476628
Coefficient of variation (CV)	2.6835329
Kurtosis	53.183284
Mean	20.300339
Median Absolute Deviation (MAD)	0
Skewness	5.5460499
Sum	1.8811541 × 10⁸
Variance	2967.703
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5348889	57.7%
1	326533	3.5%
2	257275	2.8%
3	187083	2.0%
4	161087	1.7%
6	127865	1.4%
5	127376	1.4%
7	96754	1.0%
8	88803	1.0%
9	70367	0.8%
Other values (1291)	2474582	26.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5348889	57.7%
1	326533	3.5%
2	257275	2.8%
3	187083	2.0%
4	161087	1.7%
5	127376	1.4%
6	127865	1.4%
7	96754	1.0%
8	88803	1.0%
9	70367	0.8%

Value	Count	Frequency (%)
2342	1	< 0.1%
2332	1	< 0.1%
2260	1	< 0.1%
2174	1	< 0.1%
2000	1	< 0.1%
1980	1	< 0.1%
1972	1	< 0.1%
1952	1	< 0.1%
1948	1	< 0.1%
1942	1	< 0.1%

C3
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	105
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.63660934

Minimum	0
Maximum	125
Zeros	7399318
Zeros (%)	79.8%
Negative	0
Negative (%)	0.0%
Memory size	141.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3
Maximum	125
Range	125
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.2914719
Coefficient of variation (CV)	3.5994947
Kurtosis	128.96116
Mean	0.63660934
Median Absolute Deviation (MAD)	0
Skewness	8.7540826
Sum	5899213
Variance	5.2508435
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7399318	79.8%
1	836638	9.0%
2	381935	4.1%
3	199085	2.1%
4	119241	1.3%
5	76253	0.8%
6	53743	0.6%
7	38160	0.4%
8	29353	0.3%
9	22260	0.2%
Other values (95)	110628	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7399318	79.8%
1	836638	9.0%
2	381935	4.1%
3	199085	2.1%
4	119241	1.3%
5	76253	0.8%
6	53743	0.6%
7	38160	0.4%
8	29353	0.3%
9	22260	0.2%

Value	Count	Frequency (%)
125	1	< 0.1%
113	1	< 0.1%
111	1	< 0.1%
109	1	< 0.1%
108	2	< 0.1%
106	1	< 0.1%
104	2	< 0.1%
100	1	< 0.1%
99	1	< 0.1%
97	1	< 0.1%

ANTIGUEDAD
Real number (ℝ)

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4666537

Minimum	0
Maximum	13
Zeros	3987610
Zeros (%)	43.0%
Negative	0
Negative (%)	0.0%
Memory size	106.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	6
Maximum	13
Range	13
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.0557252
Coefficient of variation (CV)	1.4016432
Kurtosis	4.4885205
Mean	1.4666537
Median Absolute Deviation (MAD)	1
Skewness	2.0403626
Sum	13590914
Variance	4.2260061
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0	3987610	43.0%
1	2331595	25.2%
2	1067682	11.5%
3	658261	7.1%
4	405704	4.4%
5	267476	2.9%
6	183504	2.0%
7	113984	1.2%
8	85511	0.9%
9	84436	0.9%
Other values (4)	80851	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3987610	43.0%
1	2331595	25.2%
2	1067682	11.5%
3	658261	7.1%
4	405704	4.4%
5	267476	2.9%
6	183504	2.0%
7	113984	1.2%
8	85511	0.9%
9	84436	0.9%

Value	Count	Frequency (%)
13	372	< 0.1%
12	4999	0.1%
11	26428	0.3%
10	49052	0.5%
9	84436	0.9%
8	85511	0.9%
7	113984	1.2%
6	183504	2.0%
5	267476	2.9%
4	405704	4.4%

EDAD
Real number (ℝ)

Distinct	78
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.050236

Minimum	18
Maximum	95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	106.0 MiB

Quantile statistics

Minimum	18
5-th percentile	22
Q1	29
median	38
Q3	50
95-th percentile	65
Maximum	95
Range	77
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	13.443758
Coefficient of variation (CV)	0.33567239
Kurtosis	-0.56137807
Mean	40.050236
Median Absolute Deviation (MAD)	10
Skewness	0.49031125
Sum	3.7113008 × 10⁸
Variance	180.73464
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	300134	3.2%
26	292116	3.2%
28	289847	3.1%
25	286100	3.1%
29	276458	3.0%
24	273458	3.0%
30	258741	2.8%
31	247693	2.7%
32	241343	2.6%
33	231829	2.5%
Other values (68)	6568895	70.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18	33260	0.4%
19	101647	1.1%
20	130305	1.4%
21	153889	1.7%
22	181253	2.0%
23	229657	2.5%
24	273458	3.0%
25	286100	3.1%
26	292116	3.2%
27	300134	3.2%

Value	Count	Frequency (%)
95	1	< 0.1%
94	4	< 0.1%
93	8	< 0.1%
92	6	< 0.1%
91	10	< 0.1%
90	8	< 0.1%
89	23	< 0.1%
88	53	< 0.1%
87	82	< 0.1%
86	145	< 0.1%

TARGET
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	141.4 MiB

0	6898694
1	2367920

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	9266614
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	6898694	74.4%
1	2367920	25.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	6898694	74.4%
1	2367920	25.6%

Most occurring characters

Value	Count	Frequency (%)
0	6898694	74.4%
1	2367920	25.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	9266614	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	6898694	74.4%
1	2367920	25.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	9266614	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	6898694	74.4%
1	2367920	25.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9266614	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	6898694	74.4%
1	2367920	25.6%

Auto

Heatmap
Table

	MES	CLIENTE	INGRESO	MORAS	MARCACIONES	CONTACTOS	M1	C1	M2	C2	M3	C3	ANTIGUEDAD	EDAD	ANIO	ESTADO	SEXO	ESTADOCIVIL	TARGET
MES	1.000	0.573	0.013	-0.115	-0.043	0.046	0.025	0.065	0.089	0.096	0.108	0.078	0.006	0.029	0.337	0.012	0.004	0.006	0.111
CLIENTE	0.573	1.000	0.031	-0.049	-0.011	0.059	0.027	0.078	0.072	0.102	0.120	0.114	-0.127	-0.061	0.510	0.044	0.010	0.018	0.076
INGRESO	0.013	0.031	1.000	-0.022	-0.003	0.055	-0.002	0.038	0.004	0.039	0.004	0.035	-0.005	0.084	0.001	0.005	0.002	0.001	0.001
MORAS	-0.115	-0.049	-0.022	1.000	0.431	-0.141	0.562	0.134	0.504	0.143	0.404	0.140	0.002	-0.097	0.048	0.019	0.014	0.024	0.119
MARCACIONES	-0.043	-0.011	-0.003	0.431	1.000	-0.117	0.535	0.099	0.346	0.077	0.283	0.095	0.003	-0.080	0.029	0.006	0.002	0.005	0.047
CONTACTOS	0.046	0.059	0.055	-0.141	-0.117	1.000	-0.108	0.440	-0.089	0.322	-0.049	0.265	-0.096	0.072	0.003	0.018	0.010	0.004	0.211
M1	0.025	0.027	-0.002	0.562	0.535	-0.108	1.000	0.348	0.609	0.213	0.432	0.189	0.017	-0.067	0.038	0.005	0.003	0.005	0.053
C1	0.065	0.078	0.038	0.134	0.099	0.440	0.348	1.000	0.166	0.448	0.127	0.351	-0.060	0.018	0.006	0.016	0.009	0.003	0.139
M2	0.089	0.072	0.004	0.504	0.346	-0.089	0.609	0.166	1.000	0.459	0.609	0.276	0.025	-0.052	0.056	0.005	0.003	0.005	0.044
C2	0.096	0.102	0.039	0.143	0.077	0.322	0.213	0.448	0.459	1.000	0.235	0.443	-0.050	0.014	0.009	0.014	0.007	0.003	0.103
M3	0.108	0.120	0.004	0.404	0.283	-0.049	0.432	0.127	0.609	0.235	1.000	0.534	0.050	-0.036	0.051	0.004	0.002	0.003	0.033
C3	0.078	0.114	0.035	0.140	0.095	0.265	0.189	0.351	0.276	0.443	0.534	1.000	-0.029	0.013	0.019	0.012	0.007	0.002	0.086
ANTIGUEDAD	0.006	-0.127	-0.005	0.002	0.003	-0.096	0.017	-0.060	0.025	-0.050	0.050	-0.029	1.000	0.107	0.047	0.043	0.031	0.051	0.046
EDAD	0.029	-0.061	0.084	-0.097	-0.080	0.072	-0.067	0.018	-0.052	0.014	-0.036	0.013	0.107	1.000	0.043	0.035	0.080	0.239	0.091
ANIO	0.337	0.510	0.001	0.048	0.029	0.003	0.038	0.006	0.056	0.009	0.051	0.019	0.047	0.043	1.000	0.034	0.005	0.008	0.090
ESTADO	0.012	0.044	0.005	0.019	0.006	0.018	0.005	0.016	0.005	0.014	0.004	0.012	0.043	0.035	0.034	1.000	0.034	0.081	0.065
SEXO	0.004	0.010	0.002	0.014	0.002	0.010	0.003	0.009	0.003	0.007	0.002	0.007	0.031	0.080	0.005	0.034	1.000	0.080	0.013
ESTADOCIVIL	0.006	0.018	0.001	0.024	0.005	0.004	0.005	0.003	0.005	0.003	0.003	0.002	0.051	0.239	0.008	0.081	0.080	1.000	0.042
TARGET	0.111	0.076	0.001	0.119	0.047	0.211	0.053	0.139	0.044	0.103	0.033	0.086	0.046	0.091	0.090	0.065	0.013	0.042	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	ANIO	MES	CLIENTE	ESTADO	INGRESO	MORAS	SEXO	ESTADOCIVIL	FECHANACIMIENTO	MARCACIONES	CONTACTOS	M1	C1	M2	C2	M3	C3	ANTIGUEDAD	EDAD	TARGET
0	2019	5	2019539059618	JALISCO	15000.0	3	M	S	1966-02-01	347	8	19	0	0	0	130	0	1	53	1
1	2019	5	2019527392560	VERACRUZ	6000.0	6	M	C	1987-07-04	113	0	71	3	42	0	30	0	5	31	0
2	2019	5	201958823716	CHIAPAS	4000.0	1	F	S	1980-05-07	177	4	100	11	13	1	14	4	0	39	0
3	2019	5	201953294752	TAMAULIPAS	4000.0	5	M	U	1989-08-30	139	0	176	1	159	11	73	11	1	29	0
4	2019	5	2019568646789	ESTADO DE MEXICO	5000.0	3	F	U	1968-05-16	89	5	28	8	11	3	0	0	0	51	0
5	2019	5	2019563063824	PUEBLA	6000.0	6	F	S	1985-07-16	103	0	108	0	62	0	23	0	1	33	0
6	2019	5	2019539910671	SINALOA	12000.0	8	M	S	1988-08-27	154	3	16	0	48	4	33	0	1	30	1
7	2019	5	2019521175745	SINALOA	8000.0	1	M	C	1975-10-22	4	1	0	0	4	0	1	0	2	43	1
8	2019	5	2019567381970	CHIAPAS	4500.0	2	M	C	1978-06-12	76	7	4	1	0	0	0	0	0	40	1
9	2019	5	2019567848537	YUCATAN	15000.0	2	M	C	1950-10-17	7	3	6	1	2	1	1	0	0	68	1

	ANIO	MES	CLIENTE	ESTADO	INGRESO	MORAS	SEXO	ESTADOCIVIL	FECHANACIMIENTO	MARCACIONES	CONTACTOS	M1	C1	M2	C2	M3	C3	ANTIGUEDAD	EDAD	TARGET
9270213	2019	4	201942011347	NUEVO LEON	0.000000	1	F	C	1974-10-10	1	1	4	1	0	0	0	0	0	44	1
9270214	2019	4	201946633818	VERACRUZ	5000.000000	1	F	S	1993-09-15	1	1	0	0	3	2	0	0	0	25	1
9270215	2019	4	2019456273055	QUERETARO	32000.000000	1	M	S	1993-12-14	2	1	0	0	2	1	5	1	0	25	0
9270216	2019	4	201947391029	GUANAJUATO	6300.000000	1	M	C	1986-04-21	2	1	0	0	4	1	4	1	0	33	1
9270217	2019	4	20194660127	SONORA	9093.477322	1	M	C	1948-06-14	1	0	0	0	0	0	0	0	10	70	0
9270218	2019	4	201942290471	SONORA	12000.000000	1	M	C	1984-01-28	2	0	18	3	11	2	4	2	4	35	0
9270219	2019	4	201947067504	ESTADO DE MEXICO	6000.000000	1	F	U	1989-02-07	2	0	0	0	14	2	6	3	1	30	0
9270220	2019	4	2019446430265	ESTADO DE MEXICO	8000.000000	1	M	S	1971-11-16	1	1	5	1	1	1	1	0	1	47	1
9270221	2019	4	201943231046	TAMAULIPAS	5600.000000	1	F	C	1968-04-24	1	1	0	0	4	1	8	1	10	51	1
9270222	2019	4	2019410035630	ESTADO DE MEXICO	0.000000	1	M	U	1987-07-05	1	0	10	1	39	2	63	6	2	31	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample